---
title: DB-CLL-056 — Update a case consolidation link
summary: Update a case consolidation link
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-056 — Update a case consolidation link

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-056 |
| Operation type | Misc |
| Execution method | StoredProc |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Stored procedure call |
| Business object | clsConsolidations |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier |
| ConsolidatedCaseID | Input | NUMBER | N/A | Identifier of the case it is consolidated into |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [CONSOLIDATED_CASE](../database-tables.md#consolidated_case) | UPDATE | LegalCaseID, ConsolidatedCaseID (inferred*) |

## Sample SQL

```sql
EXEC pk80001_LEGALNET.UpdateConsolidatedCase(:LegalCaseID, :ConsolidatedCaseID);  -- inferred*
```

## Operations and processes

- [Manage case consolidation](../operations/manage-case-consolidation.md)

## Business rules

- [BR-CLM-LGL-025](../business-rules.md#br-clm-lgl-025-consolidation-schedule-non-production-behavior-suppression)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb`